class RatingsSideffects < ActiveRecord::Migration
  def self.up
    create_table :ratings_sideffects, :options=>"ENGINE=MyISAM", :id => false  do |t|
      t.integer :sideffect_id, :null => false
      t.integer :rating_id, :null => false
    end
    add_index(:ratings_sideffects, [:rating_id,:sideffect_id])
    add_index(:ratings_sideffects, [:sideffect_id, :rating_id])      
  end

  def self.down
    drop_table :ratings_sideffects
  end
end
